Function Libraries Group on the Metrics Tab
The Acumen metric editor supports all MS Excel functions. Use the ribbon commands to select MS Excel formulas.
The most commonly used formulas are grouped in the Common function library. Other function libraries include:
- Financial
- Logical
- Text
- Date & Time
- Lookup & Reference
- Math & Trig
- Statistical
- Information
Acumen Functions
The Acumen functions library includes the following functions:
- FISCALPERIODNUM: Use this function to return the corresponding fiscal period number for a given DateTime. The function includes two parameters:
- Any date field on the object
- The Project field
For example: FISCALPERIODNUM(Start, Project)
- Related Topics:
- Examples of Common Functions
This topic includes descriptions and examples of the formulas listed in the Metric tab Common function library.
Parent Topic: Ribbon Commands on the Metrics Tab